To Embed a SQL List
- After selecting the Embedded SQL list option, select OK.
- Under the newly created property, right-click the Domain List node and choose Add > Add Domain SQL. Key in an SQL statement as shown, including an ORDER BY clause if the domain list should be sorted. Alternatively, key in the SQL statement directly into the Domain List grid.
- Selecting the cache option will cause the SELECT statement to be run once when first used during a session resulting in improved performance. If not selected, the SELECT statement will be run each time it is accessed.
- Select the property node and define the Value Col Name and Edit Col Name as shown.
- The Value Col Name is the column from the query that will be stored in the property.
- The Edit Column name is the column from the query that will be displayed in the combo box.
- Provide a Tool Tip to prompt the user on what type of entry is expected.
